rams erd
Tables (9)
category (카테고리)
- cate_seq — int(20) — Primary key — NOT NULL
- cate_user_seq — int(20)
- cate_company_seq — int(20)
- cate_ref_seq — int(20)
- cate_depth — tinyint(20)
- cate_name — varchar(100)
- cate_json — text
- cate_od — int(20)
company (CopyOfUntitled)
- Key (company_seq) — int(20) — Primary key — NOT NULL
- Field2 (company_name) — varchar(100)
- Field3 (company_biz) — varchar(300)
- Field4 (company_user_seq) — int(20)
- Field5 (company_addr1) — varchar(100)
- Field6 (company_tel) — varchar(50)
- Field7 (company_thumbnail) — varchar(100)
- Field8 (company_dt_reg) — datetime
contractor (CopyOfCopyOfUntitled)
- Key (contr_seq) — Primary key — NOT NULL
- Field2 (contr_company_seq)
- Field3 (contr_part)
- Field4 (contr_writer)
- Field5 (contr_company)
- Field6 (contr_code)
- Field7 (contr_location)
- Field8 (contr_respon_person)
- Field9 (contr_purpose)
- Field10 (contr_respon_hp)
- Field11 (contr_start_date)
- Field12 (contr_end_date)
contractorUserInfo (CopyOfCopyOfCopyOfUntitled2)
- Key (con_user_seq_seq) — Primary key — NOT NULL
- Field2 (con_user_company_seq)
- Field3 (con_user_cibtr_seq)
- Field4 (con_user_name)
- Field5 (con_user_gender)
- Field6 (con_user_addr)
- Field7 (con_user_security_number)
- Field8 (con_user_hp)
- Field9 (con_user_work_name)
- Field10 (con_user_rams_number)
- Field11 (con_user_dt_reg)
filedb (CopyOfCopyOfCopyOfUntitled22)
- Key (file_seq) — Primary key — NOT NULL
- Field7 (file_company_seq)
- Field2 (file_gid)
- Field3 (file_eid)
- Field4 (file_name)
- Field5 (file_real_name)
- Field8 (file_path)
grade (CopyOfCopyOfUntitled3)
- Key (grade_seq) — Primary key — NOT NULL
- Field2 (grade_company_seq)
- Field3 (grade_grade)
- Field4 (grade_od)
meta (CopyOfCopyOfUntitled4)
- Key (meta_seq) — Primary key — NOT NULL
- Field2 (meta_user_seq)
- Field3 (meta_company_seq)
- Field4 (meta_json)
- Field5 (meta_dt_reg)
team (CopyOfCopyOfUntitled2)
- Key (team_seq) — Primary key — NOT NULL
- Field2 (team_company_seq)
- Field3 (team_depth)
- Field4 (team_parent_depth)
- Field5 (team_name)
user (CopyOfUntitled2)
- Key (user_seq) — Primary key — NOT NULL
- Field2 (user_id)
- Field3 (user_name)
- Field4 (user_pass)
- Field5 (user_tel)
- Field6 (user_tel_in)
- Field7 (user_hp)
- Field8 (user_email)
- Field9 (user_dt_login)
- Field10 (user_dt_reg)