Virajsinh

DataBase Table Design

Feb 29th, 2020
67
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. // Creating tables
  2. Table registration {
  3.   id int [pk, increment] // auto-increment
  4.   first_name varchar(20)
  5.   last_name varchar(20)
  6.   gender enum('Male','Female')
  7.   birthdate time
  8.   blood_group int
  9.   occupation int
  10.   occupation_type var
  11.   state int
  12.   dist int
  13.   sub_dist int
  14.   village var(20)
  15.   post_code var(6)
  16.   email var
  17.   first_mobile var
  18.   second_mobile var
  19.   status enum('Active','Inactive')
  20.   verify enum('true','false')
  21.   created_at timestamp
  22. }
RAW Paste Data