큐시즘

테이블 (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)