큐시즘
테이블 (13)
Activity
- At_code — int — 기본 키 — NOT NULL
- User_code — int — 외래 키 → User.User_code — NOT NULL
- At_title — varchar(100)
- At_content — varchar(500)
- At_currentNumber — int
- At_recruitNumber — int
- At_hostIntro — varchar(100)
- At_place — varchar(100)
- At_intro — var(1500)
- At_price — int
Activity_Category
- At_code (Key2) — int — 외래 키 → Activity.At_code — NOT NULL
- AC_tag (Field) — varchar(10)
At_apply
- Aa_code — int — 기본 키 — NOT NULL
- At_code — int — 외래 키 → Activity.At_code — NOT NULL
- Aa_id — varchar(20)
- Aa_enter (Field2) — boolean
At_like
- At_code — int — 외래 키 → Activity.At_code — NOT NULL
- Atl_id (Field) — varchar(20)
At_photo
- At_code (Key2) — 외래 키 → Activity.At_code — NOT NULL
- Apt_filename (Field)
- Apt_randomName (Field2)
InterestCountry
- User_code — int — 외래 키 → User.User_code — NOT NULL
- Country_name — varchar(30)
Pid
- Pid_code — int — 기본 키 — NOT NULL
- User_code — int — 외래 키 → User.User_code — NOT NULL
- Pid_title (Field) — varchar(100)
- Pid_content — varchar(1500)
- Pid_dday (Field3) — Date
- Pid_currentNumber (Field4) — int
- Pid_recruitNumber (Field5) — int
- Pid_religion (Field6) — varchar(70)
- Pid_startDate (Field7) — Date
- Pid_finish (Field8) — boolean
Pid_Category
- Pid_code — int — 외래 키 → Pid.Pid_code — NOT NULL
- PC_tag — varchar(20)
Pid_apply
- Pa_code — int — 기본 키 — NOT NULL
- Pid_code — int — 외래 키 → Pid.Pid_code — NOT NULL
- Pa_id — varchar(20)
- Pa_enter — boolean
Pid_like
- Pid_code — int — 외래 키 → Pid.Pid_code — NOT NULL
- pl_id — varchar(20)
Pid_photo
- Pid_code — int — 외래 키 → Pid.Pid_code — NOT NULL
- Pp_filename (Field) — varchar(500)
- Pp_randomName (Field2) — varchar(500)
Pid_reply
- Pr_code — int — 기본 키 — NOT NULL
- Pid_code — int — 외래 키 → Pid.Pid_code — NOT NULL
- Pr_writeDate — Date
- Pr_content — varchar(150)
- Pr_author — varchar(20)
User
- User_code — int — 기본 키 — NOT NULL
- User_name — varchar(30)
- User_country — varchar(30)
- User_nickname — varchar(30)
- User_introduction — varchar(1000)
- User_id — varchar(20)
- User_password — varchar(20)
- User_sex — boolean
- User_birth — Date
- User_photo — varchar(500)