young

Tables (3)

data

  • number (등록번호) — notnull — Primary key — NOT NULL
  • title (제목) — notnull
  • content (내용) — notnull
  • date (날자) — notnull
  • ok (삭제여부) — notnull
  • userID (아이디) — notnull — Foreign key → user.userID — NOT NULL

order

  • orderNum (주문번호) — notnull — Primary key — NOT NULL
  • model (모델) — notnull
  • moter (옵션) — notnull
  • wheel (휠) — notnull
  • sheet (시트색상) — notnull
  • sheetNum (시트) — notnull
  • userID (아이디) — notnull — Foreign key → user.userID — NOT NULL

user (tesla)

  • userID (아이디) — notnull — Primary key — NOT NULL
  • userPassword (패스워드) — notnull
  • userEmail (이메일) — null
  • userAddress (주소) — null
  • userPhone (핸드폰) — null